SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE dbo.[DnnProduct_GetPortalByPortalAliasID]

	@PortalAliasId  int

AS
SELECT P.*
FROM dbo.DnnProduct_vw_Portals P
	INNER JOIN dbo.DnnProduct_PortalAlias PA ON P.PortalID = PA.PortalID
WHERE PA.PortalAliasId = @PortalAliasId

GO
